DROP TABLE IF EXISTS jms_dim.dim_lmdm_sys_network_distributi_dt;
CREATE EXTERNAL TABLE jms_dim.dim_lmdm_sys_network_distributi_dt(
 NETWORK_ID bigint comment "网点ID",  --NUMBER(11)
 ID bigint comment "交派货分拨ID",  --NUMBER(11)
 NAME string comment "交派货分拨名称",  --NVARCHAR2(60)
 CODE string comment "交派货分拨编码",  --NVARCHAR2(20)
 DISTRIBUTION_TYPE bigint comment "1 可派货分拨  2 可交货分拨",  --NUMBER(11)
 CREATE_BY bigint comment "创建人ID",  --NUMBER(11)
 UPDATE_BY bigint comment "最后更新人ID",  --NUMBER(11)
 CREATE_BY_NAME string comment "创建人名称",  --NVARCHAR2(50)
 UPDATE_BY_NAME string comment "最后修改人名称",  --NVARCHAR2(50)
 CREATE_TIME timestamp comment "创建时间",  --DATE
 UPDATE_TIME timestamp comment "更新时间",  --DATE
 P_ID bigint comment "" ,   --NUMBER(11)
 IS_DEFAULT string comment "所属转运中心标识"   --NVARCHAR2(2)
 network_code string comment'网点code',
 network_name string comment'网点name'
 )
 COMMENT '网点交货分拨中间表维表'
 STORED AS PARQUET
 LOCATION '/dw/hive/jms_dim.db/external/dim_lmdm_sys_network_distributi_dt'
 TBLPROPERTIES (
 'discover.partitions'='false',
 'parquet.column.index.access'='true'
 );
